begin tran

declare @upd_id int
select @upd_id = convert(int, var_data) from igs_parm with(updlock) where var_name = 'gv_upd_id'

update ms_style set upd_id = @upd_id,
size_group = case size_group 
when 'F-PANTS'  then '24-32'
when 'F-SHOES' then '35-40'
when 'H-PANTS' then '28-36'
when 'H-PANTS2' then '46-52'
when 'H-SHOES' then '38-44'
when 'SHIRT'   then 'F-XXL'
when 'SKIN-CARE' then '25-1000'
when 'USA-SHOES' then 'US2-US12' 
else size_group end
where size_group in('F-PANTS','F-SHOES','H-PANTS','H-PANTS2','H-SHOES', 'SHIRT','SKIN-CARE', 'USA-SHOES')

update ms_sizeseq 
set size_grp =
case size_grp 
when 'F-PANTS'  then '24-32'
when 'F-SHOES' then '35-40'
when 'H-PANTS' then '28-36'
when 'H-PANTS2' then '46-52'
when 'H-SHOES' then '38-44'
when 'SHIRT'   then 'F-XXL'
when 'SKIN-CARE' then '25-1000'
when 'USA-SHOES' then 'US2-US12' 
else size_grp end, upd_id = @upd_id

select *  from ms_sizeseq order by size_grp, seq_no

rollback tran